Main
Kyle PATRICK Simpson
ETL/ELT Pipeline Support Specialist | Researrch Analyst | Data Technician
Data analyst with 5+ years experience supporting data pipelines, automating workflows, and integrating datasets using SQL, Python, R, and Excel/Googlesheets. Strong focus on data quality, reporting accuracy, and translating complex data into operational decisions. Experience across Non-profit, Hospitality/Retail, Public Health, and Environmental Research sectors.
Relevant Work History
Inventory & Quality Assurance Analyst
M2 by Matcha Matcha
Toronto, Ont
2024
- Engineered a data structure integrating POS, Sales, and Recipes to feed downstream reporting and interactive dashboards.
- Drove operational Quality Assurance using data for compliance testing on production outputs and service standards.
- Created dashboards and reports with integrated data, optimizing ordering, and reducing waste.
Data Migration Technician
Lions Foundation of Canada Dog Guides
Oakville, Ont
2022
- Managed ETL consolidation into Salesforce, performing data mapping and ensuring 100% data integrity.
- Implemented Excel VBA automated workflow for validation, reducing errors and improving efficiency by 33%.
- Authored SOPs and documentation for data entry, assessing data quality, and troubleshooting workflows.
Data & Systems Administrator
Accident Compensation Commission of New Zealand
Dunedin, NZ
2022 - 2021
- Executed primary triage on data quality tickets, identifying anomalies and discrepancies in accident claims and healthcare data.
- Systematically documented known issues and bottlenecks within the data pipeline to guide resolution.
- Collaborated across teams to fix critical data issues, mitigating downstream implications on accident claim cover decisions.
Managing Director / Data Systems Consultant
Bar Squire Beverage Consultancy Services
Wellington, NZ
2021 - 2020
- Created a centralized database, integrating data from multiple sources to inform data-driven consultancy to businesses and events.
- Applied SQL and Python for analysis and troubleshooting system issues and data structures of client/company systems.
- Provided advisory services on data systems and reporting, translating raw data into business intelligence.
Research Analyst
Greenback Ltd.
Auckland, NZ
2020 - 2019
- Led data acquisition via API calls and web scraping, expanding the knowledge base for research.
- Performed extensive data cleaning and validation, preparing datasets for dashboards and reporting.
- Partnered with engineers on data curation and analysis, optimizing data for application development.